<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connections/A146240Connection.jsp" %>
<%
String getProductOrderList__MMColParam = "1";
if (request.getParameter("orderId") !=null) {getProductOrderList__MMColParam = (String)request.getParameter("orderId");}
%>
<%
Driver DrivergetProductOrderList = (Driver)Class.forName(MM_A146240Connection_DRIVER).newInstance();
Connection ConngetProductOrderList = DriverManager.getConnection(MM_A146240Connection_STRING,MM_A146240Connection_USERNAME,MM_A146240Connection_PASSWORD);
PreparedStatement StatementgetProductOrderList = ConngetProductOrderList.prepareStatement("SELECT PRODUCT_ID, ORDER_AMOUNT FROM A152786.ORDER_PRODUCT WHERE ORDER_ID = " + getProductOrderList__MMColParam + " ORDER BY PRODUCT_ID ASC");
ResultSet getProductOrderList = StatementgetProductOrderList.executeQuery();
boolean getProductOrderList_isEmpty = !getProductOrderList.next();
boolean getProductOrderList_hasData = !getProductOrderList_isEmpty;
Object getProductOrderList_data;
int getProductOrderList_numRows = 0;
%>
<%
int Repeat1__numRows = -1;
int Repeat1__index = 0;
getProductOrderList_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>

<table border="1">
  <tr>
    <td>PRODUCT_ID</td>
    <td>ORDER_AMOUNT</td>
  </tr>
  <% while ((getProductOrderList_hasData)&&(Repeat1__numRows-- != 0)) { %>
  <tr>
    <td><%=(((getProductOrderList_data = getProductOrderList.getObject("PRODUCT_ID"))==null || getProductOrderList.wasNull())?"":getProductOrderList_data)%></td>
    <td><%=(((getProductOrderList_data = getProductOrderList.getObject("ORDER_AMOUNT"))==null || getProductOrderList.wasNull())?"":getProductOrderList_data)%></td>
  </tr>
  <%
  Repeat1__index++;
  getProductOrderList_hasData = getProductOrderList.next();
}
%>
</table>
</body>
</html>
<%
getProductOrderList.close();
StatementgetProductOrderList.close();
ConngetProductOrderList.close();
%>
